Page 55 - Data_Science_Part_A C12

For Example, A formula, say as A6=A1+A2+A3+A4+A5 can be written using the SUM function along with the cell range
A6 as: =SUM(A1:A5)

Name is the name of the function that signifies the nature of operation. Argument specifies the values or the range of
cells on which the specific operation is being applied and is always enclosed within the opening and closing parenthesis
(i.e. Name refers to the operator and Argument refers to the operand).

3.10.6 Mathematical Functions

These functions perform mathematical calculations on the specified arguments. Some mathematical functions are:
Table 3.1: A

Function Description
SUM(X,Y,..) It produces the sum of the numbers for a range of cells. E.g., =SUM(C1 ...C4), =SUM(C1:C4)
(will produce the addition of cells from C1 to C4)

ABS(X) It produces the positive (absolute) value of a given integer.
E.g., =ABS(-8)=8, =ABS(4)=4, =ABS(-3.7)=3.7
INT(X) It produces the integer value of a given integer.
E.g., =INT(12.54)=12, =INT(-8.72)=-9

SQRT(X) It produces the square root of a positive integer.
E.g., =SQRT(9) = 3, =SQRT(2) = 1.414213562
ROUND(X,Y) It produces the value of X that is rounded to the number of digits specified by Y.

E.g., =ROUND(12.234,2)= 12.23, =ROUND(32.67,0)=33
MOD(X,Y) It produces the remainder of X divided by Y.
E.g., =MOD(11,2) = 1, =MOD(90,2) = 0
POWER(X,Y) It produces the value of X raised to the power of Y.
E.g., =POWER(5,2)=25, =POWER(-5,0.5)=#NUM!

PRODUCT(X,Y) It multiplies all the given arguments.
E.g., =PRODUCT(5,2,3) = 30, =PRODUCT(-5,6,0) = 0
3.10.7 Date and Time Functions

We can add the date and time in a cell. Built into LibreOffice Calc are a number of DATE and TIME functions that can be
used to do this.
Table 3.2: A

Function Description

TODAY( ) Produces the current date; it contains no argument.

NOW( ) Produces the current date and time; it contains no argument.
YEAR(“Date”) Returns the year from a date value. E.g. =YEAR(DATE(2024,3,2))

MONTH(“Date”) Returns the month from a date value (1-12). E.g.,
=MONTH(DATE(2024,3,2)) returns “3” for March.
DAY(“Date”) Returns the day of the month from a date value. E.g., =DAY(DATE(2024,3,2))

ICT Skills-III 53